StaffGroup 
EntityType  Independent 
Logical Entity Name  StaffGroup 
Default Table Name  SyStaffGroup 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StaffGroup Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Code    CHAR(8)  NO 
 
Name    VARCHAR(40)  NO 
 
IsActive    BIT  NO 
 
ModFlag    CHAR(1)  NO 
 
IsSystemCode    BIT  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  YES 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StaffGroupId(PK)    INTEGER  NO 
 
IsRequiredForEnroll    BIT  NO 
 
AdvisorModule(FK)    CHAR(8)  YES 
 
CanOverrideLeadDuplicateWarning    BIT  NO 
 
GroupType    CHAR(4)  YES 
 
AllowDropLDAAttendChange    BIT  NO 
 
IsCampusLinkAmbassadorUse    BIT  NO 
 
IsPositivePayUse    BIT  NO 
 
IsExcludedCrmIntegration    BIT  NO 
 

StaffGroup Keys 
Key Name  Key Type  Keys 
SyStaffGroup_AdvisorModule_N_N_IDX  Inversion Entry  AdvisorModule 
SyStaffGroup_Code_N_N_IDX  Inversion Entry  Code 
SyStaffGroup_SyStaffGroupID_U_C_IDX  PrimaryKey  StaffGroupId 

StaffGroup Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Module  Non-Identifying  Zero or One to Zero or More        AdvisorModule  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentAdvisor  Non-Identifying  One To Zero or More          NO 
TaskAddTrigger  Non-Identifying  One To Zero or More          NO 
cmStaffGroupAccess  Non-Identifying  One To Zero or More          NO 
AutoAwardPaymentPlanSetting  Non-Identifying  One To Zero or More          NO 
FaCashPlanWorkflowAudit  Non-Identifying  One To Zero or More          NO 
FaCashPlanWorkflowAudit  Non-Identifying  One To Zero or More          NO 
StudentAwardPromNotePrintAssignment  Non-Identifying  One To Zero or More          NO 
FaPromNotePrintAudit  Non-Identifying  One To Zero or More          NO 
FaPromNotePrintAudit  Non-Identifying  One To Zero or More          NO 
FaStudentAidCashPlanAssignment  Non-Identifying  One To Zero or More          NO 
AchBatchFileSetting  Non-Identifying  One To Zero or More          NO 
BillingTransactionCodeStaffGroup  Non-Identifying  One To Zero or More          NO 
DisbursementReceiptNotification  Non-Identifying  One To Zero or More          NO 
StudentRt4CalculationPostWithdrawalDisbursementAssignment  Non-Identifying  One To Zero or More          NO 
PostWithdrawalDisbursementConfigurationDetail  Non-Identifying  One To Zero or More          NO 
SaPWDRoutingTemplate  Non-Identifying  One To Zero or More          NO 
SaRefundCalculationAssignment  Non-Identifying  One To Zero or More          NO 
SaRefundCalculationRoutingTemplate  Non-Identifying  One To Zero or More          NO 
SaRefundCalculationWorkflowAudit  Non-Identifying  One To Zero or More          NO 
SaRefundCalculationWorkflowAudit  Non-Identifying  One To Zero or More          NO 
SaReturnOfT4Assignment  Non-Identifying  One To Zero or More          NO 
StudentRt4CalculationPostWithdrawalDisbursementAssignmentDataChange  Non-Identifying  One To Zero or More          NO 
StudentRt4CalculationPostWithdrawalDisbursementAssignmentDataChange  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 
Si_Packages_Security  Non-Identifying  One To Zero or More          NO 
CampusDefaultStudentAdvisor  Identifying  One To Zero or More          NO 
EmployerContactTypeStaffGroup  Non-Identifying  One To Zero or More          NO 
StaffGroupFundSourcePermission  Non-Identifying  One To Zero or More          NO 
SchoolStatusDetailStaffGroup  Identifying  One To Zero or More          NO 
SecurityMenuAuthorization  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionAssignment  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionAssignment  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionDataChange  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionDataChange  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionDataChange  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionDataChange  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionTypeCampusTemplate  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionCustomActionDocumentReview  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionOverrideUser  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionSearchFilterUser  Non-Identifying  One To Zero or More          NO 
FaaProcessExceptionTypeTemplate  Non-Identifying  One To Zero or More          NO 
SyServiceNotificationTemplateAssignment  Non-Identifying  One To Zero or More          NO 
SyServicePerformanceGoalsAssignment  Non-Identifying  One To Zero or More          NO 
FaaStaffGroupDelegation  Non-Identifying  One To Zero or More          NO 
FaaStaffGroupHierarchy  Non-Identifying  One To Zero or More          NO 
FaaStaffGroupHierarchy  Non-Identifying  One To Zero or More          NO 
StaffGroupMember  Non-Identifying  One To Zero or More          NO 
StaffGroupRefreshRule  Non-Identifying  One To Zero or More          NO 
StaffGroupTemplateSetting  Non-Identifying  One To Zero or More          NO 
SyStatusGridStaffGroup  Identifying  One To Zero or More          NO 
WorkspaceStaffGroup  Non-Identifying  One To Zero or More          NO 
EmployerContactTypeStaffGroup  Non-Identifying  One To Zero or More          NO 
StudentAdvisorDataChange  Non-Identifying  One To Zero or More          NO 
TaskPolicyDetail  Non-Identifying  One To Zero or More          NO 

StaffGroup Check Constraints 
Check Constraint Name  CheckConstraint 

StaffGroup Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StaffGroup 
NO       
Physical (Microsoft SQL Server)
dbo.SyStaffGroup 
NO       

StaffGroup Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Addresses_Affiliations 
Logical  Employers 
Logical  StudentEnrollment 
Logical  Tasks 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  System 

StaffGroup Data Movement Rules 
Name  Type  Rule Text/Value